oracle dba commands

Test environment: win2003 + oracle10gr2 Set environment variables:Set ORACLE_HOME = D: \ oracle \ product \ 10.2.0 \ db_1Set java_home = % ORACLE_HOME % \ JDKSet Path = % java_home % \ bin; % PATH % Go to the ISQLPLUS directory:Cd % ORACLE_HOME % \ Solaris \ J2EE \ ISQLPLUS \ Application-deployments \ ISQLPLUS Enter the jazn command environment:Java-djava. security. properties = % ORACLE_HOME %/sqlplus/admin/iplus/provider-jar % ORACLE_HOME %/Solaris/

After reading the manuscript "Oracle DBA manual" sent by eygle, I felt that the writing idea of this book was quite new. With the improvement of Database Technology automation, DBA's work value has begun to expand to a greater level. Therefore, sharing the experiences of some Pathfinder has become particularly valuable. Exposing its thinking process is a major feature of the technology circle in the web era

As a DBA, you must learn the following 11 basic Linux commands that will not die: dbalinux Most databases run on Linux and UNIX platforms. As the computing power of the X86 platform approaches or even exceeds that of minicomputers, and with the tide of IOE removal, more and more databases run on the Linux platform. The Linux system is huge and complex. As a DBA,

**************************************** **************************************** **************************************** **** Blue growth note-Chase DBA (7): Basic commands, foundation stone **************************************** ***************************** *************************************** Personal Growth records on the oracle Road, expressed in blu

The vast majority of databases run on Linux and UNIX platforms, and as the X86 platform's computing power nears or exceeds minicomputer, and in the tide of the IoE, more and more database environments run on Linux platforms.The Linux system is large and complex, summarized as a DBA, some basic management, network management, advanced applications, performance diagnostics, pipeline complex applications, hardware-related sensing

Tags: Wind brother Oracle Oracle Training Oracle Database tutorial Oracle video wind Brother Oracle TutorialsBecause it is a "top secret leaked" information, to prevent the investigation, the need for the small partners to quickly download the attached courseware document.Be

Oracle Oracle DAB two day crash course The purpose of this course is to supplement the DBA's two-day quick (2 days dba) manual. In this course, you will learn more about the tasks outlined in the DBA's two-day quick (2 days dba) manual, and include step-by-step instructions. To view the information for this course

Label:The Linux system is large and complex, summarized as a DBA, some basic management, network management, advanced applications, performance diagnostics, pipeline complex applications, hardware-related sensing commands need to master, this article, specifically as a DBA, must learn the 11 basic application commands.

Oracle Pen questions Oracle DBA face questions and answers (foreign companies)Oracle Database Pen Test DBAOracle Interview Pen test for international large companiesOracle Database DBA Interview Questions1. How many memory layers are in the shared pool?2. How did you find th

PrefaceThis article describes DBA's daily responsibilities in monitoring Oracle databases and how to use shell scripts to perform repeated monitoring. This article first reviews some common DBA Unix Commands and explains how to regularly execute DBA scripts through UNIX cron. The article also introduces eight important

Finally put OCP DBA's course all finished, tired Ah! Overall Oracle certification is worth the test. I have CCNP, MCSE certificate, but through the DBA examination, feel not only deepened the understanding of modern databases, but also enrich the knowledge structure of computer science. I think, in some ways, Oracle databases even have some operating system capab

-- The above two phrases will intercept the transaction records, as long as they are executed, the transaction record is not successful until the next complete preparation!-- subtract log the size of the file (LOG file name reduced by up to DBCC Shrinkfile (beedb_log,+)/******** The position of the DB ********/-- Check the location of DBSelectname,Physical_name fromSYS.master_fileswheredatabase_id=db_id(' Salepony ')-- swap out the location of the DBAlter Database Salemodify file

necessary to adjust database performance(4). database performance AdjustmentAdjust the performance if necessary(5) propose the next space management planBased on weekly monitoring, this paper proposes an improvement method for space management. Routine Oracle DBA managementObjective: This document provides detailed information about one or more ORACLE databases

xmlns:dc="http://purl.org/dc/elements/1.1/"xmlns:trackback="http://madskills.com/public/xml/rss/module/trackback/">rdf:about="http://www.blogjava.net/cymao/archive/2006/03/30/38289.html"dc:identifier="http://www.blogjava.net/cymao/archive/2006/03/30/38289.html"dc:title="DBA的职责和任务(转自oracle中文技术论坛)"trackback:ping="http://www.blogjava.net/cymao/services/trackbacks/38289.aspx" />--> It is from the

The following articles mainly describe the Common commands of Oracle DBA through the code of the actual application. If you are a beginner in Oracle DBA, you can use the following articles to understand the specific operations or related functions. The following is an introd

Why is it so difficult to find a good Oracle DBA? This is not only the pain of many CIOs, but also the problem that many IT directors cannot solve. But where do so many people who have obtained OCP certification from ORACLE training courses go? Tom is a database administrator with An OCP license and a certain understanding of the database architecture and operat

, the hope from the system construction and the professional quality of engineers to start, to prevent the DBA of this random dangerous operation.But, after all, the management system is "soft", the hope rests on the engineer consciously abide by the system and "self-cultivation" on, and can not guarantee foolproof.The security components provided by Oracle can be used to limit, block, and prevent such rand

Differences between sys and system users 1) The most important difference is that the importance of stored data is different. Base tables and views of all ORACLE data dictionaries in SYS are stored in SYS users. These base tables and views are crucial for Oracle operation and are maintained by the database, no user can change it manually. Sys users have the role or permissions such as

Tags: adding to Oinstall and DBA user groupsUsermod-g oinstall-g dba-d/home/oracle Oracle-G is the Oinstall group for the specified user's primary group-G is the DBA group for the specified user's secondary group-D for the specified user's home directorystatement is defined

With the rapid development of Oracle technology and the market, the number of people working in Oracle DBA is getting bigger and bigger. I can see from some posts that I often post on forums and communities, many people are eager to work in this field now or in the future, and the market demand is also very large, but it is not hard to see that each company has h